package cn.dwrService;



import java.util.ArrayList;
import java.util.List;

import cn.bean.AccBean;
import cn.service.ManagerService;
import cn.util.Common;
import cn.util.ReturnBean;
import cn.util.SqlUtil;

public class AccManager {
	private ManagerService managerService;

	public ManagerService getManagerService() {
		return managerService;
	}

	public void setManagerService(ManagerService managerService) {
		this.managerService = managerService;
	}
	public ReturnBean qryAccResult(){
		List param=new ArrayList();
		param.add("10A");
		List res=managerService.qryJDBCSql(SqlUtil.sqls[16],param);
		AccBean bean=new AccBean();
		bean.setUserTotal(res.get(0).toString());
		param.clear();
		param.add("70N");
		res=managerService.qryJDBCSql(SqlUtil.sqls[17],param);
		Object[] temp=(Object[])res.get(0);
		bean.setOrderTotal(temp[0].toString());
		bean.setMoneyTotal(temp[1].toString());
		return Common.success(bean);
	}
}
